Date Jump Error in Excel [FIXED]

Today's TipsMake will help you solve the automatic date jumping error in Excel. If you find this extremely inconvenient, quickly refer to the admin's article!

Sometimes entering data into a spreadsheet, including dates, can give you a headache. Because the date formatting conventions of different regions are different, or your date input needs are different. Therefore, an incorrect date jump error in Excel can cause you to have to fix it very time-consuming. TipsMake has found some effective solutions in the next section.

Date Jump Error in Excel [FIXED] Picture 1

Instructions on how to fix automatic date jumping error in Excel very quickly

Jumping dates in Excel on your phone/computer is not a strange thing. This feature is quite convenient to help users enter dates quickly. But sometimes it's not right, for example, you just want to enter the number 1/11 but Excel automatically jumps to November 1 or January 11, for example. Here are ways to fix this situation in one fell swoop.

1/ Format columns before entering or pasting data

If you want Excel to not automatically jump dates when you enter data. First, format the column/row before entering the number.

1. Step 1 : The user clicks on the column or cell where you need to enter numeric data > Click on the Home tab .
2. B2 : Click the arrow next to the format line > Select Text > Then, you enter numeric data as usual, Excel will not automatically jump to the date. Besides, in the data entry box you can also press Ctrl + 1 > Select the format you need and then press OK to finish.

Date Jump Error in Excel [FIXED] Picture 3

2/ Turn off automatic date jumping in Excel

If you do not want Excel to enter numbers into dates, you can do the following to turn off this feature. Note, there is no solution to completely disable date jumping in Excel. The tip below will apply to a few cells if you need to enter not too many numbers. If you import in bulk, you can apply the above method!

1. Create a space before entering data. Note, you need to make sure that when you press Enter, this space still exists.
2. Please add an apostrophe (') before entering data. For example '11-323 or '1/47. Don't worry because after you press Enter, this apostrophe will disappear and will not affect your document.
3. Zero and a space before you enter For a fraction such as 1/2 or ¾. If you want to avoid changing it to January 2 or March 4, type 0 and a space before entering the data. Type 0 1/2 or 0 3/4. After clicking Enter, the 0 will be lost and the number in the cell will become a decimal number.

Date Jump Error in Excel [FIXED] Picture 5

See more: How to create a function that automatically jumps dates in Excel

Not only does it show you how to turn off the automatic date jumping feature in Excel. I will also show you how to create a date jump function in Excel for those who need it. This function is not difficult, you do it as follows:

1. If you want to fill in date, month, and year information into the cell, enter the =TODAY() function.
2. If you want to display the day, month, year and time in the cell, enter the function =NOW()

These are two real-time functions and automatically update when restarting the Excel file. Information will be obtained based on Windows real time!

The error of automatically jumping dates in Excel is very simple to solve, right? TipsMake wishes you success!

Lesley Montoya

Update 11 December 2023